UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mOr729gbBJaguk50XYIPI/fgXt0yLGn02vqpoDJfDE='
WHERE
key_id = '04c835c4ebe2cc8beb4045630b1d5ba8e5b70923de9ce2dde9515154587dfdd4'
AND (
token = '8mOr729gbBJaguk50XYIPI/fgXt0yLGn02vqpoDJfDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)