UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W5XcVXEpIgEZlDC33Uh8xfxamgdEhhTl5VbSxA9p0EA='
WHERE
key_id = '8fc9dce412316c9c0e7e6ad8e46fe791f1ce809b5294cc10ac40efad6868f2c4'
AND (
token = 'W5XcVXEpIgEZlDC33Uh8xfxamgdEhhTl5VbSxA9p0EA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)