UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KFg6kMpfp7GVLD69y+I4TX8lE3BuIpB4H2GeD8rleG0='
WHERE
key_id = 'c793d5342c993962c88b43e228a5ff2d9efb038669a280a00bb4044d544d0fc8'
AND (
token = 'KFg6kMpfp7GVLD69y+I4TX8lE3BuIpB4H2GeD8rleG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)