UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zXkdLriQY/11WpMtZhumIMoyXR5PekrvBSGUZvpCAE='
WHERE
key_id = '851e53136a863c221627d7506ca9fbae0941255a6283938cafa8ae6d642cb91b'
AND (
token = '0zXkdLriQY/11WpMtZhumIMoyXR5PekrvBSGUZvpCAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)