UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lFlMgboXftrJ4DNUg4aA8FOVer66nE/PGHNq9iiTkgk='
WHERE
key_id = '8f8ed15b61bcbca1f5a13f7578ba06f0a83da4f4a105b34efe9481d2a43de70e'
AND (
token = 'lFlMgboXftrJ4DNUg4aA8FOVer66nE/PGHNq9iiTkgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)