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