UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nGFfkihCWC2MnOtDD4F+zN03YtKB8FM5vnCU96Y3Nyw=' 
WHERE 
  key_id = '1857fa4c91ba3035e52118247ec076dfdc239c850f2c99f4b7de3ba3f44b9179' 
  AND (
    token = 'nGFfkihCWC2MnOtDD4F+zN03YtKB8FM5vnCU96Y3Nyw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017