UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irwv31RRsTSRi97IkodBpzCZ6df0ziD7R4sEWiiJpe8='
WHERE
key_id = 'a232b480f15e6be241589645882e4efb789fc87252783fc4ec9b81c4c7e35127'
AND (
token = 'irwv31RRsTSRi97IkodBpzCZ6df0ziD7R4sEWiiJpe8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)