UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'he9xFa34t1r2N6uYduLEphEYIMPY9DOLn3zJWYbDOS8='
WHERE
key_id = '16f01476ee1d1bc5732e59d32c39b4bfa14297aa5e9eacb056ca2907c27b9827'
AND (
token = 'he9xFa34t1r2N6uYduLEphEYIMPY9DOLn3zJWYbDOS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)