UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRTz5IYVsf9jtamCrq7oKUwyXOh+OQibIYOAhJV5WPw='
WHERE
key_id = 'e3bcb5e6f3b4c28bc0bad49da51ca98bc8ef20b4c22a4ef37f369a306933245c'
AND (
token = 'xRTz5IYVsf9jtamCrq7oKUwyXOh+OQibIYOAhJV5WPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)