UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TNJn2l/HR+9G/aOHWmIvq3dKnzBWDOa7dBMdz/C0oUg=' 
WHERE 
  key_id = 'e85f772cbcbaf7b1760c0a5bfcf79330f81c92d81c03a39717ff67664564918a' 
  AND (
    token = 'TNJn2l/HR+9G/aOHWmIvq3dKnzBWDOa7dBMdz/C0oUg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042