UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C74vpMGrLZbq1sy+iNtLTc4hsdyg2cYyMS8Ku8evrvI='
WHERE
key_id = 'a6f42780563dcfb7c1b6ecc8ea35452d3160d6400b731dce06f94bd4d9a4f817'
AND (
token = 'C74vpMGrLZbq1sy+iNtLTc4hsdyg2cYyMS8Ku8evrvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)