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