UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VRqFeAnHWFS831VM/WJ1iI/Lpk97yKqavdYHa3zfeUs='
WHERE
key_id = '9bb56530b1465e453bde1071ac99cd7b36d545f14aca49059793e46bf9d709ad'
AND (
token = 'VRqFeAnHWFS831VM/WJ1iI/Lpk97yKqavdYHa3zfeUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)