UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZ4gbhLq7q1+omRl+cKrByb9p9Ja5UrC1X/tfqjY8Gw='
WHERE
key_id = '9786bc078ae6a4687b65b57e4f8dc4acad4f2c030fa399e4b812d09082c96289'
AND (
token = 'nZ4gbhLq7q1+omRl+cKrByb9p9Ja5UrC1X/tfqjY8Gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)