UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LneA9RtvNgFnIAYAik8mkBuAY5uTCtH+1EYU9PSXM8='
WHERE
key_id = '56aa6b8991558572a44cb8d97a70626f542a6f79992dceed7fa1975e6767272a'
AND (
token = '9LneA9RtvNgFnIAYAik8mkBuAY5uTCtH+1EYU9PSXM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)