UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8CKke4evSckIdIjxX5ftsYPlgJ3WRSKiVOanuJpbxtg=' 
WHERE 
  key_id = 'bbda7d018cf94769d546f90baa88b6d6f5fde32aed8f9d967a8aa9433f3541f0' 
  AND (
    token = '8CKke4evSckIdIjxX5ftsYPlgJ3WRSKiVOanuJpbxtg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043