UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vRqLrJrnsBaS2SPMoX6EII3D3RX+qG5yBEUo3vBxCSY='
WHERE
key_id = 'b17603cc5b5188e476e38dbea3840aa2831d06be88ab36aafa89bd22dae7b528'
AND (
token = 'vRqLrJrnsBaS2SPMoX6EII3D3RX+qG5yBEUo3vBxCSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)