UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hkuoymjh8xByikHBmE0Y/EsGGN16ZyoQccxOJsvjrsM='
WHERE
key_id = '0e785e780b87cf94dc0b0fd54ea1b7f419d0e995511fcddceccd54d14abf274e'
AND (
token = 'Hkuoymjh8xByikHBmE0Y/EsGGN16ZyoQccxOJsvjrsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)