UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgoGpmztHVidwu032uDB6mikKv8tcfsduMAjdbBzix0='
WHERE
key_id = '6de2ff028fb6ba893932e9e28266e3427e207214daf77d6e79dec2d743226fc3'
AND (
token = 'sgoGpmztHVidwu032uDB6mikKv8tcfsduMAjdbBzix0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)