UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCBYp6KnV0alEXrAHiH9qtlwP29Dt0dwMV4BBhADeGQ='
WHERE
key_id = 'cb6f2f16e76acd46f55532e5cea5b24bc100ed4b6ddfaa84e047e32bcf4e9859'
AND (
token = 'CCBYp6KnV0alEXrAHiH9qtlwP29Dt0dwMV4BBhADeGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)