UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEiG7ssb7KJ31FSKF3vG36ezPy2feGIpJuE4jB0+Hok='
WHERE
key_id = '8770b75498dd92b3a6c8f9377c9feeb115f20ee15ba9342f1b60e88d7944e71f'
AND (
token = 'oEiG7ssb7KJ31FSKF3vG36ezPy2feGIpJuE4jB0+Hok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)