UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idvpI8LJpvOvc8ic7nvE1KshxC6q+qx6NZbS23JPsk4='
WHERE
key_id = 'b17237157244611f8376ef042ea4543f4efae4540c29ece386ce9f4dcae7a0db'
AND (
token = 'idvpI8LJpvOvc8ic7nvE1KshxC6q+qx6NZbS23JPsk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)