UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+BBAN9P3wOmUB5O8v8JDHGMQTP/V0Q2Nu0/xSJkDvbM=' 
WHERE 
  key_id = 'c19e1315bc4e2a776c09315954c7a4df41b7500ab4e3854c8a6bcaae7f81cbe6' 
  AND (
    token = '+BBAN9P3wOmUB5O8v8JDHGMQTP/V0Q2Nu0/xSJkDvbM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043