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