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