UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j7jjaAPgXKXVdYWA5K0QQg69NBNq/JLgx76oq06kKGU='
WHERE
key_id = 'a193cf6c7759a3f1504d5906499e2578b52312b003c0fcba819b1af6110f4341'
AND (
token = 'j7jjaAPgXKXVdYWA5K0QQg69NBNq/JLgx76oq06kKGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)