UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24dtrqQuTE50ygY7cRPaWXa1ffO3Dzj0ydG2ig6RMtQ='
WHERE
key_id = '3df4368756430ac0466aba124d98efbff584e71b5f0f012ea5338456353700c3'
AND (
token = '24dtrqQuTE50ygY7cRPaWXa1ffO3Dzj0ydG2ig6RMtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)