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