UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Kp2aMqDK5ShBbo1j5ZZ47Gjo0Q85ItEAZn4VKy4qLCc=' 
WHERE 
  key_id = '4557160f6e7da06cd786283fe18b1d2bb9b1186607821cb3bb2f858ed1c76b16' 
  AND (
    token = 'Kp2aMqDK5ShBbo1j5ZZ47Gjo0Q85ItEAZn4VKy4qLCc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044