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