UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49fYCkM8g08R+9krJEWuV3yj4V8Jz4iOJJ2AGfHjCBY='
WHERE
key_id = '942adc6cb1ed8a8b4a82fb03122e789748da48af62216acdd252ec5f91282454'
AND (
token = '49fYCkM8g08R+9krJEWuV3yj4V8Jz4iOJJ2AGfHjCBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)