UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CGmN0NNdi6jUiRePZ/Dpty3Z+tmP+34M5bXDBZxW8PQ=' 
WHERE 
  key_id = '7ef02caa1bab6ed1f4127ac06c2389e7d1de08f10c28eff25f8e3960c2b2be5b' 
  AND (
    token = 'CGmN0NNdi6jUiRePZ/Dpty3Z+tmP+34M5bXDBZxW8PQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00057