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