UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lk5VHJ1TZg505vESa0XrF3JKIfFlYK2aQCHsPgMJ2/A='
WHERE
key_id = '0acd724b6bc5848a07ae367af41ca07425a08145931c6f9f3fe7c4010b6f7804'
AND (
token = 'Lk5VHJ1TZg505vESa0XrF3JKIfFlYK2aQCHsPgMJ2/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)