UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mgmcovcR9UiHEXIb7xgxZ4dbG29M+ZG6PPYOytzkCoc='
WHERE
key_id = '238db17a1617f6699c13d6a26b7a41c02602d9244e932f9cdd9b4e56910ab968'
AND (
token = 'mgmcovcR9UiHEXIb7xgxZ4dbG29M+ZG6PPYOytzkCoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)