UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aft+cVgtS4lTqv/5Y8D/57Bja9aVkZz+sxe4+JPs+1M='
WHERE
key_id = 'ea46ee1eb3a4de8d69c9e0456c09ac9f640cb97bcb83afd371a3e055c3aac0c6'
AND (
token = 'aft+cVgtS4lTqv/5Y8D/57Bja9aVkZz+sxe4+JPs+1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)