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