UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCUyycxfzBULKWk4NM1Vp2E+F+c7fRaTYkfydzit/gU='
WHERE
key_id = '7bfa9d3f83d2faa2beaedbd2892ce785863f582c04e842de6f29154841834dea'
AND (
token = 'xCUyycxfzBULKWk4NM1Vp2E+F+c7fRaTYkfydzit/gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)